package com.cs.beneficios.web.action;
import com.cs.beneficios.business.entity.ReporteTotalGrupoFamiliarDAO;
import com.cs.beneficios.common.ConnectionFactory;
import java.sql.SQLException;
import java.util.Collection;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
//import org.apache.struts.action.ActionError;
//import org.apache.struts.action.ActionErrors;
import java.io.IOException;
import javax.servlet.ServletException;

public class IndividualReportRGFAction extends Action 
{
  /**
   * This is the main action called from the Struts framework.
   * @param mapping The ActionMapping used to select this instance.
   * @param form The optional ActionForm bean for this request.
   * @param request The HTTP Request we are processing.
   * @param response The HTTP Response we are processing.
   * @return 
   * @throws java.io.IOException
   * @throws javax.servlet.ServletException
   */
  public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
  {
    HttpSession session = request.getSession();
    //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
	ConnectionFactory cf = new ConnectionFactory();
    
    session.removeAttribute("ListIndividualReport");
    String strCodeGrupoFam = request.getParameter("codeGrupoFamiliar");
    Collection coReporte = null;
    ReporteTotalGrupoFamiliarDAO objReportGrupo = null;
    
    if(strCodeGrupoFam != null && !strCodeGrupoFam.equals(""))
    {
      try
      {
        objReportGrupo = new ReporteTotalGrupoFamiliarDAO(cf);
        coReporte = objReportGrupo.getIndividualReport(strCodeGrupoFam);
        cf.closeConnection(objReportGrupo.getConn());      
      }catch(SQLException e)
      {
		System.err.println("/******** TDSUB - cwsub");
		e.printStackTrace();
		System.err.println("TDSUB - cwsub ********/");
      }
      if(coReporte != null && coReporte.size() != 0)
        session.setAttribute("ListIndividualReport",coReporte);
    }else
    {
      request.setAttribute("MsgError","No hay registros que cumplan con el grupo familiar");
    }
      
    return mapping.findForward("success");
  }
}